﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        /*
         * Select * from foodsource table fs join foodsourcetype t on 
         * fs.typeid = t.id
         */

        DataTable foodSource = new DataTable();

        foodSource.Columns.Add("Id", typeof(string));
        foodSource.Columns.Add("Source", typeof(string));
        foodSource.Columns.Add("Type", typeof(string));

        foodSource.Rows.Add(1, "Jones Family", "Individual");
        foodSource.Rows.Add(2, "Smiths #724", "Grocery Rescue");
        foodSource.Rows.Add(3, "Utah Food Bank", "USDAA");
        foodSource.Rows.Add(4, "Smith Family", "Individual");
        foodSource.Rows.Add(5, "Jones Family", "Individual");
        foodSource.Rows.Add(6, "Smiths #724", "Grocery Rescue");
        foodSource.Rows.Add(7, "Utah Food Bank", "USDAA");
        foodSource.Rows.Add(8, "Smith Family", "Individual");

        grdDonors.DataSource = foodSource;
        grdDonors.DataBind();
    }
}